package com.jeecg.o2o.city.controller;

import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStreamReader;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import java.util.Set;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.validation.ConstraintViolation;
import javax.validation.Validator;

import org.apache.commons.lang3.StringUtils;
import org.apache.log4j.Logger;
import org.jeecgframework.core.beanvalidator.BeanValidators;
import org.jeecgframework.core.common.controller.BaseController;
import org.jeecgframework.core.common.exception.BusinessException;
import org.jeecgframework.core.common.hibernate.qbc.CriteriaQuery;
import org.jeecgframework.core.common.model.json.AjaxJson;
import org.jeecgframework.core.common.model.json.DataGrid;
import org.jeecgframework.core.constant.Globals;
import org.jeecgframework.core.util.ExceptionUtil;
import org.jeecgframework.core.util.MyBeanUtils;
import org.jeecgframework.core.util.PinyinUtil;
import org.jeecgframework.core.util.ResourceUtil;
import org.jeecgframework.jwt.util.ResponseMessage;
import org.jeecgframework.jwt.util.Result;
import org.jeecgframework.poi.excel.ExcelImportUtil;
import org.jeecgframework.poi.excel.entity.ExportParams;
import org.jeecgframework.poi.excel.entity.ImportParams;
import org.jeecgframework.poi.excel.entity.vo.NormalExcelConstants;
import org.jeecgframework.tag.core.easyui.TagUtil;
import org.jeecgframework.web.system.service.SystemService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.HttpStatus;
import org.springframework.http.MediaType;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.ResponseStatus;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.multipart.MultipartHttpServletRequest;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.util.UriComponentsBuilder;

import com.alibaba.fastjson.JSON;
import com.google.gson.JsonArray;
import com.google.gson.JsonObject;
import com.google.gson.JsonParser;
import com.jeecg.o2o.city.entity.CityEntity;
import com.jeecg.o2o.city.service.CityServiceI;

import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import io.swagger.annotations.ApiParam;

/**
 * @Title: Controller
 * @Description: 城市
 * @author onlineGenerator
 * @date 2019-03-06 22:46:56
 * @version V1.0
 *
 */

@Api(value = "v1", description = "城市", tags = "v1")
@Controller
@RequestMapping("/appapi/v1")
public class CityController extends BaseController {

	/**
	 * Logger for this class
	 */
	private static final Logger logger = Logger.getLogger(CityController.class);

	@Autowired
	private CityServiceI cityService;
	@Autowired
	private SystemService systemService;
	@Autowired
	private Validator validator;

	@RequestMapping(params = "cities")
	@ResponseBody
	public AjaxJson cities(HttpServletRequest request, String type) {
		try {
			String encoding = "UTF-8";
			File file = new File("E:\\city.txt");
			if (file.isFile() && file.exists()) { // 判断文件是否存在
				InputStreamReader read = new InputStreamReader(new FileInputStream(file), encoding);// 考虑到编码格式
				BufferedReader bufferedReader = new BufferedReader(read);
				String lineTxt = null;
				String js = "";
				while ((lineTxt = bufferedReader.readLine()) != null) {
					// System.out.println(lineTxt);
					js = js + lineTxt;
				}
				read.close();
				JsonObject returnData = new JsonParser().parse(js).getAsJsonObject();
				JsonArray JsonArray = returnData.get("provinceList").getAsJsonArray();
				for (int n = 0; n < JsonArray.size(); n++) {
					JsonArray JsonArraycity = JsonArray.get(n).getAsJsonObject().get("cityList").getAsJsonArray();
					for (int t = 0; t < JsonArraycity.size(); t++) {
						String cityname = JsonArraycity.get(t).getAsJsonObject().get("name").toString().replace("\"",
								"");
						CityEntity CityEntity1 = new CityEntity();
						CityEntity1.setName(cityname);
						CityEntity1.setFirstname(
								String.valueOf(PinyinUtil.getHeadByChar(cityname.charAt(0))).substring(0, 1));
						this.cityService.save(CityEntity1);
						// JsonArray JsonArraycounty =
						// JsonArraycity.get(t).getAsJsonObject().get("countyList")
						// .getAsJsonArray();
						// for (int y = 0; y < JsonArraycounty.size(); y++) {
						// String name =
						// JsonArraycounty.get(y).getAsJsonObject().get("name").toString().replace("\"",
						// "");
						// CityEntity CityEntity = new CityEntity();
						// CityEntity.setName(name);
						// CityEntity.setFirstname(String.valueOf(PinyinUtil.getHeadByChar(name.charAt(0))));
						// this.cityService.save(CityEntity);
						// }
					}
				}
			} else {
				System.out.println("找不到指定的文件");

			}
		} catch (Exception e) {

		}
		if (type != null && type.equals("guess")) {

		} else if (type != null && type.equals("hot")) {

		} else if (type != null && type.equals("group")) {

		}
		AjaxJson j = new AjaxJson();
		return j;
	}

	/**
	 * 城市列表 页面跳转
	 * 
	 * @return
	 */
	@RequestMapping(params = "list")
	public ModelAndView list(HttpServletRequest request) {
		return new ModelAndView("com/jeecg/o2o.city/cityList");
	}

	/**
	 * easyui AJAX请求数据
	 * 
	 * @param request
	 * @param response
	 * @param dataGrid
	 * @param user
	 */
	@RequestMapping(params = "datagrid")
	public void datagrid(CityEntity city, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
		CriteriaQuery cq = new CriteriaQuery(CityEntity.class, dataGrid);
		// 查询条件组装器
		org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, city, request.getParameterMap());
		cq.add();
		this.cityService.getDataGridReturn(cq, true);
		TagUtil.datagrid(response, dataGrid);
	}

	/**
	 * 删除城市
	 * 
	 * @return
	 */
	@RequestMapping(params = "doDel")
	@ResponseBody
	public AjaxJson doDel(CityEntity city, HttpServletRequest request) {
		String message = null;
		AjaxJson j = new AjaxJson();
		city = systemService.getEntity(CityEntity.class, city.getId());
		message = "城市删除成功";
		try {
			cityService.delete(city);
			systemService.addLog(message, Globals.Log_Type_DEL, Globals.Log_Leavel_INFO);
		} catch (Exception e) {
			e.printStackTrace();
			message = "城市删除失败";
			throw new BusinessException(e.getMessage());
		}
		j.setMsg(message);
		return j;
	}

	/**
	 * 批量删除城市
	 * 
	 * @return
	 */
	@RequestMapping(params = "doBatchDel")
	@ResponseBody
	public AjaxJson doBatchDel(String ids, HttpServletRequest request) {
		String message = null;
		AjaxJson j = new AjaxJson();
		message = "城市删除成功";
		try {
			for (String id : ids.split(",")) {
				CityEntity city = systemService.getEntity(CityEntity.class, Integer.parseInt(id));
				cityService.delete(city);
				systemService.addLog(message, Globals.Log_Type_DEL, Globals.Log_Leavel_INFO);
			}
		} catch (Exception e) {
			e.printStackTrace();
			message = "城市删除失败";
			throw new BusinessException(e.getMessage());
		}
		j.setMsg(message);
		return j;
	}

	/**
	 * 添加城市
	 * 
	 * @param ids
	 * @return
	 */
	@RequestMapping(params = "doAdd")
	@ResponseBody
	public AjaxJson doAdd(CityEntity city, HttpServletRequest request) {
		String message = null;
		AjaxJson j = new AjaxJson();
		message = "城市添加成功";
		try {
			cityService.save(city);
			systemService.addLog(message, Globals.Log_Type_INSERT, Globals.Log_Leavel_INFO);
		} catch (Exception e) {
			e.printStackTrace();
			message = "城市添加失败";
			throw new BusinessException(e.getMessage());
		}
		j.setMsg(message);
		return j;
	}

	/**
	 * 更新城市
	 * 
	 * @param ids
	 * @return
	 */
	@RequestMapping(params = "doUpdate")
	@ResponseBody
	public AjaxJson doUpdate(CityEntity city, HttpServletRequest request) {
		String message = null;
		AjaxJson j = new AjaxJson();
		message = "城市更新成功";
		CityEntity t = cityService.get(CityEntity.class, city.getId());
		try {
			MyBeanUtils.copyBeanNotNull2Bean(city, t);
			cityService.saveOrUpdate(t);
			systemService.addLog(message, Globals.Log_Type_UPDATE, Globals.Log_Leavel_INFO);
		} catch (Exception e) {
			e.printStackTrace();
			message = "城市更新失败";
			throw new BusinessException(e.getMessage());
		}
		j.setMsg(message);
		return j;
	}

	/**
	 * 导入功能跳转
	 * 
	 * @return
	 */
	@RequestMapping(params = "upload")
	public ModelAndView upload(HttpServletRequest req) {
		req.setAttribute("controller_name", "cityController");
		return new ModelAndView("common/upload/pub_excel_upload");
	}

	/**
	 * 导出excel
	 * 
	 * @param request
	 * @param response
	 */
	@RequestMapping(params = "exportXls")
	public String exportXls(CityEntity city, HttpServletRequest request, HttpServletResponse response,
			DataGrid dataGrid, ModelMap modelMap) {
		CriteriaQuery cq = new CriteriaQuery(CityEntity.class, dataGrid);
		org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, city, request.getParameterMap());
		List<CityEntity> citys = this.cityService.getListByCriteriaQuery(cq, false);
		modelMap.put(NormalExcelConstants.FILE_NAME, "城市");
		modelMap.put(NormalExcelConstants.CLASS, CityEntity.class);
		modelMap.put(NormalExcelConstants.PARAMS,
				new ExportParams("城市列表", "导出人:" + ResourceUtil.getSessionUser().getRealName(), "导出信息"));
		modelMap.put(NormalExcelConstants.DATA_LIST, citys);
		return NormalExcelConstants.JEECG_EXCEL_VIEW;
	}

	/**
	 * 导出excel 使模板
	 * 
	 * @param request
	 * @param response
	 */
	@RequestMapping(params = "exportXlsByT")
	public String exportXlsByT(CityEntity city, HttpServletRequest request, HttpServletResponse response,
			DataGrid dataGrid, ModelMap modelMap) {
		modelMap.put(NormalExcelConstants.FILE_NAME, "城市");
		modelMap.put(NormalExcelConstants.CLASS, CityEntity.class);
		modelMap.put(NormalExcelConstants.PARAMS,
				new ExportParams("城市列表", "导出人:" + ResourceUtil.getSessionUser().getRealName(), "导出信息"));
		modelMap.put(NormalExcelConstants.DATA_LIST, new ArrayList());
		return NormalExcelConstants.JEECG_EXCEL_VIEW;
	}

	@SuppressWarnings("unchecked")
	@RequestMapping(params = "importExcel", method = RequestMethod.POST)
	@ResponseBody
	public AjaxJson importExcel(HttpServletRequest request, HttpServletResponse response) {
		AjaxJson j = new AjaxJson();

		MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
		Map<String, MultipartFile> fileMap = multipartRequest.getFileMap();
		for (Map.Entry<String, MultipartFile> entity : fileMap.entrySet()) {
			MultipartFile file = entity.getValue();// 获取上传文件对象
			ImportParams params = new ImportParams();
			params.setTitleRows(2);
			params.setHeadRows(1);
			params.setNeedSave(true);
			try {
				List<CityEntity> listCityEntitys = ExcelImportUtil.importExcel(file.getInputStream(), CityEntity.class,
						params);
				for (CityEntity city : listCityEntitys) {
					cityService.save(city);
				}
				j.setMsg("文件导入成功！");
			} catch (Exception e) {
				j.setMsg("文件导入失败！");
				logger.error(ExceptionUtil.getExceptionMessage(e));
			} finally {
				try {
					file.getInputStream().close();
				} catch (IOException e) {
					e.printStackTrace();
				}
			}
		}
		return j;
	}

	@RequestMapping(method = RequestMethod.GET)
	@ResponseBody
	@ApiOperation(value = "城市列表信息", produces = "application/json", httpMethod = "GET")
	public ResponseMessage<List<CityEntity>> list() {
		List<CityEntity> listCitys = cityService.getList(CityEntity.class);
		return Result.success(listCitys);
	}

	@RequestMapping(value = "/{id}", method = RequestMethod.GET)
	@ResponseBody
	@ApiOperation(value = "根据ID获取城市信息", notes = "根据ID获取城市信息", httpMethod = "GET", produces = "application/json")
	public ResponseMessage<?> get(@ApiParam(required = true, name = "id", value = "ID") @PathVariable("id") String id) {
		CityEntity task = cityService.get(CityEntity.class, id);
		if (task == null) {
			return Result.error("根据ID获取城市信息为空");
		}
		return Result.success(task);
	}

	@RequestMapping(method = RequestMethod.POST, consumes = MediaType.APPLICATION_JSON_VALUE)
	@ResponseBody
	@ApiOperation(value = "创建城市")
	public ResponseMessage<?> create(@ApiParam(name = "城市对象") @RequestBody CityEntity city,
			UriComponentsBuilder uriBuilder) {
		// 调用JSR303 Bean Validator进行校验，如果出错返回含400错误码及json格式的错误信息.
		Set<ConstraintViolation<CityEntity>> failures = validator.validate(city);
		if (!failures.isEmpty()) {
			return Result.error(JSON.toJSONString(BeanValidators.extractPropertyAndMessage(failures)));
		}

		// 保存
		try {
			cityService.save(city);
		} catch (Exception e) {
			e.printStackTrace();
			return Result.error("城市信息保存失败");
		}
		return Result.success(city);
	}

	@RequestMapping(value = "/{id}", method = RequestMethod.PUT, consumes = MediaType.APPLICATION_JSON_VALUE)
	@ResponseBody
	@ApiOperation(value = "更新城市", notes = "更新城市")
	public ResponseMessage<?> update(@ApiParam(name = "城市对象") @RequestBody CityEntity city) {
		// 调用JSR303 Bean Validator进行校验，如果出错返回含400错误码及json格式的错误信息.
		Set<ConstraintViolation<CityEntity>> failures = validator.validate(city);
		if (!failures.isEmpty()) {
			return Result.error(JSON.toJSONString(BeanValidators.extractPropertyAndMessage(failures)));
		}

		// 保存
		try {
			cityService.saveOrUpdate(city);
		} catch (Exception e) {
			e.printStackTrace();
			return Result.error("更新城市信息失败");
		}

		// 按Restful约定，返回204状态码, 无内容. 也可以返回200状态码.
		return Result.success("更新城市信息成功");
	}

	@RequestMapping(value = "/{id}", method = RequestMethod.DELETE)
	@ResponseStatus(HttpStatus.NO_CONTENT)
	@ApiOperation(value = "删除城市")
	public ResponseMessage<?> delete(
			@ApiParam(name = "id", value = "ID", required = true) @PathVariable("id") String id) {
		logger.info("delete[{}]" + id);
		// 验证
		if (StringUtils.isEmpty(id)) {
			return Result.error("ID不能为空");
		}
		try {
			cityService.deleteEntityById(CityEntity.class, id);
		} catch (Exception e) {
			e.printStackTrace();
			return Result.error("城市删除失败");
		}

		return Result.success();
	}
}
